lContinue = true if(!database.connected()) { write("Could not connect to the database.") lContinue = false } if (lContinue) { qo = unescape("%22") alias = "" groupname = request.groupname description = "" commissioner = "" cRoutine = "ADD" cGroupname = replchar(request.groupname," ","+") write("

Form for Joining "+groupname+" League

") write("
") writeln("
") writeln("") writeln("") writeln("
") write("Player List
") write("Search Player List
") write("League List
") write("Home Page") writeln("
") writeln("
") writeln("
") csql = "select league_open from groupm where groupname = '" + request.groupname + "'" curstmp = database.cursor(csql) lpassword = false cleague_open = true if (request.msg) writeln(request.msg + "

") if (curstmp.next()) { cleague_open = curstmp.league_open if (curstmp.league_open == "O") { lContinue = true } else if (curstmp.league_open == "C") { lContinue = false writeln("
Sorry. The commissioner of this league has decided ") writeln("to close the league to new players.
") } else if (curstmp.league_open == "P") { writeln("
The commissioner of this league has configured it so that ") writeln("a password is neccessary to join. You must supply both the password and your alias ") writeln("to continue.
") lpassword = true lContinue = true } } curstmp.close() if (lContinue) { write("
") writeln("") writeln("") write("
") write("") writeln("") if (lpassword) { writeln("") writeln(" ") } write("
Alias
League PasswordConfirm
") } }